import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class SqlTest {
	
	  public static void main(String args[]) throws SQLException {
	
		Connection con = null;
		Statement st = null;
		ResultSet rs = null;

		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bedandbreakfast",
				  "root", "");		
		
		st = con.createStatement();
	
		rs = st.executeQuery("SELECT name FROM suite WHERE S_ID=1");
		
		System.out.println(rs);

}
}